Overview

Dataset Statistics

Number of Variables 13
Number of Rows 10000
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 1.5 MB
Average Row Size in Memory 160.9 B
Variable Types
  • DateTime: 1
  • Categorical: 2
  • Numerical: 10

Dataset Insights

admitted_pui and discharged_pui have similar distributions Similar Distribution
admitted_covid and admitted_total have similar distributions Similar Distribution
admitted_covid and discharged_covid have similar distributions Similar Distribution
admitted_covid and discharged_total have similar distributions Similar Distribution
admitted_total and discharged_covid have similar distributions Similar Distribution
admitted_total and discharged_total have similar distributions Similar Distribution
discharged_covid and discharged_total have similar distributions Similar Distribution
beds is skewed Skewed
admitted_pui is skewed Skewed
admitted_covid is skewed Skewed
admitted_total is skewed Skewed
discharged_pui is skewed Skewed
discharged_covid is skewed Skewed
discharged_total is skewed Skewed
pkrc_covid is skewed Skewed
pkrc_pui is skewed Skewed
pkrc_noncovid is skewed Skewed
year has constant length 4 Constant Length
admitted_pui has 6868 (68.68%) zeros Zeros
admitted_covid has 2862 (28.62%) zeros Zeros
admitted_total has 2479 (24.79%) zeros Zeros
discharged_pui has 7082 (70.82%) zeros Zeros
discharged_covid has 2805 (28.05%) zeros Zeros
discharged_total has 2468 (24.68%) zeros Zeros
pkrc_covid has 1624 (16.24%) zeros Zeros
pkrc_pui has 5533 (55.33%) zeros Zeros
pkrc_noncovid has 7722 (77.22%) zeros Zeros
  • 1
  • 2
  • 3

Variables


date

datetime

Distinct Count 926.5186
Approximate Unique (%) 9.3%
Missing 0
Missing (%) 0.0%
Memory Size 80128
Minimum 2020-03-28 00:00:00
Maximum 2022-12-01 00:00:00

state

categorical

Approximate Distinct Count 16
Approximate Unique (%) 0.2%
Missing 0
Missing (%) 0.0%
Memory Size 728951

Length

Mean 7.8951
Standard Deviation 2.9468
Median 7
Minimum 5
Maximum 17

Sample

1st row Kelantan
2nd row Perlis
3rd row Pulau Pinang
4th row Sarawak
5th row Selangor

Letter

Count 75083
Lowercase Letter 62017
Space Separator 2264
Uppercase Letter 13066
Dash Punctuation 0
Decimal Number 0

beds

numerical

Approximate Distinct Count 1029
Approximate Unique (%) 10.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 1338.99
Minimum 0
Maximum 11345
Zeros 14
Zeros (%) 0.1%
Negatives 0
Negatives (%) 0.0%
  • beds is skewed right (γ1 = 2.335)

Quantile Statistics

Minimum 0
5-th Percentile 48
Q1 189
Median 709
Q3 1690
95-th Percentile 5428
Maximum 11345
Range 11345
IQR 1501

Descriptive Statistics

Mean 1338.99
Standard Deviation 1772.6496
Variance 3.1423e+06
Sum 1.339e+07
Skewness 2.335
Kurtosis 5.9557
Coefficient of Variation 1.3239
  • beds is not normally distributed (p-value 1.8060878385533804e-18)
  • beds has 890 outliers

admitted_pui

numerical

Approximate Distinct Count 95
Approximate Unique (%) 0.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 2.5779
Minimum 0
Maximum 190
Zeros 6868
Zeros (%) 68.7%
Negatives 0
Negatives (%) 0.0%
  • admitted_pui is skewed right (γ1 = 10.0089)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1
95-th Percentile 12
Maximum 190
Range 190
IQR 1

Descriptive Statistics

Mean 2.5779
Standard Deviation 9.4723
Variance 89.7239
Sum 25779
Skewness 10.0089
Kurtosis 134.4558
Coefficient of Variation 3.6744
  • admitted_pui is not normally distributed (p-value 7.473711033093291e-25)
  • admitted_pui has 1999 outliers

admitted_covid

numerical

Approximate Distinct Count 648
Approximate Unique (%) 6.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 72.7656
Minimum 0
Maximum 2040
Zeros 2862
Zeros (%) 28.6%
Negatives 0
Negatives (%) 0.0%
  • admitted_covid is skewed right (γ1 = 4.6122)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 17
Q3 78
95-th Percentile 318
Maximum 2040
Range 2040
IQR 78

Descriptive Statistics

Mean 72.7656
Standard Deviation 148.9542
Variance 22187.3636
Sum 727656
Skewness 4.6122
Kurtosis 30.3331
Coefficient of Variation 2.047
  • admitted_covid is not normally distributed (p-value 1.1019638161313065e-23)
  • admitted_covid has 1043 outliers

admitted_total

numerical

Approximate Distinct Count 665
Approximate Unique (%) 6.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 75.3435
Minimum 0
Maximum 2042
Zeros 2479
Zeros (%) 24.8%
Negatives 0
Negatives (%) 0.0%
  • admitted_total is skewed right (γ1 = 4.4988)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 1
Median 19
Q3 81
95-th Percentile 327
Maximum 2042
Range 2042
IQR 80

Descriptive Statistics

Mean 75.3435
Standard Deviation 151.0679
Variance 22821.5177
Sum 753435
Skewness 4.4988
Kurtosis 28.9325
Coefficient of Variation 2.0051
  • admitted_total is not normally distributed (p-value 1.3701101779235596e-23)
  • admitted_total has 1059 outliers

discharged_pui

numerical

Approximate Distinct Count 92
Approximate Unique (%) 0.9%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 2.0717
Minimum 0
Maximum 305
Zeros 7082
Zeros (%) 70.8%
Negatives 0
Negatives (%) 0.0%
  • discharged_pui is skewed right (γ1 = 12.2771)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1
95-th Percentile 9
Maximum 305
Range 305
IQR 1

Descriptive Statistics

Mean 2.0717
Standard Deviation 8.5618
Variance 73.3037
Sum 20717
Skewness 12.2771
Kurtosis 248.4287
Coefficient of Variation 4.1327
  • discharged_pui is not normally distributed (p-value 4.923358939975887e-25)
  • discharged_pui has 1660 outliers

discharged_covid

numerical

Approximate Distinct Count 644
Approximate Unique (%) 6.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 72.3816
Minimum 0
Maximum 2278
Zeros 2805
Zeros (%) 28.1%
Negatives 0
Negatives (%) 0.0%
  • discharged_covid is skewed right (γ1 = 4.7754)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 17
Q3 78
95-th Percentile 314.1
Maximum 2278
Range 2278
IQR 78

Descriptive Statistics

Mean 72.3816
Standard Deviation 148.3021
Variance 21993.5101
Sum 723816
Skewness 4.7754
Kurtosis 33.3308
Coefficient of Variation 2.0489
  • discharged_covid is not normally distributed (p-value 6.136582083833234e-24)
  • discharged_covid has 1040 outliers

discharged_total

numerical

Approximate Distinct Count 651
Approximate Unique (%) 6.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 74.4533
Minimum 0
Maximum 2278
Zeros 2468
Zeros (%) 24.7%
Negatives 0
Negatives (%) 0.0%
  • discharged_total is skewed right (γ1 = 4.6591)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 1
Median 18
Q3 81
95-th Percentile 329.05
Maximum 2278
Range 2278
IQR 80

Descriptive Statistics

Mean 74.4533
Standard Deviation 150.1217
Variance 22536.5283
Sum 744533
Skewness 4.6591
Kurtosis 31.8928
Coefficient of Variation 2.0163
  • discharged_total is not normally distributed (p-value 7.163511747641632e-24)
  • discharged_total has 1044 outliers

pkrc_covid

numerical

Approximate Distinct Count 2146
Approximate Unique (%) 21.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 530.9822
Minimum 0
Maximum 6685
Zeros 1624
Zeros (%) 16.2%
Negatives 0
Negatives (%) 0.0%
  • pkrc_covid is skewed right (γ1 = 2.8138)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 10
Median 138
Q3 576
95-th Percentile 2734.05
Maximum 6685
Range 6685
IQR 566

Descriptive Statistics

Mean 530.9822
Standard Deviation 932.4419
Variance 869447.8991
Sum 5.3098e+06
Skewness 2.8138
Kurtosis 8.9646
Coefficient of Variation 1.7561
  • pkrc_covid is not normally distributed (p-value 2.873653833345965e-23)
  • pkrc_covid has 1120 outliers

pkrc_pui

numerical

Approximate Distinct Count 405
Approximate Unique (%) 4.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 23.1663
Minimum 0
Maximum 1079
Zeros 5533
Zeros (%) 55.3%
Negatives 0
Negatives (%) 0.0%
  • pkrc_pui is skewed right (γ1 = 6.4425)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 9
95-th Percentile 88.05
Maximum 1079
Range 1079
IQR 9

Descriptive Statistics

Mean 23.1663
Standard Deviation 84.7875
Variance 7188.9279
Sum 231663
Skewness 6.4425
Kurtosis 47.8458
Coefficient of Variation 3.66
  • pkrc_pui is not normally distributed (p-value 6.098581499845259e-25)
  • pkrc_pui has 1607 outliers

pkrc_noncovid

numerical

Approximate Distinct Count 218
Approximate Unique (%) 2.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 160000
Mean 14.3991
Minimum 0
Maximum 884
Zeros 7722
Zeros (%) 77.2%
Negatives 0
Negatives (%) 0.0%
  • pkrc_noncovid is skewed right (γ1 = 4.5045)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 0
95-th Percentile 90
Maximum 884
Range 884
IQR 0

Descriptive Statistics

Mean 14.3991
Standard Deviation 38.3226
Variance 1468.6207
Sum 143991
Skewness 4.5045
Kurtosis 43.7131
Coefficient of Variation 2.6615
  • pkrc_noncovid is not normally distributed (p-value 6.055045230994782e-25)
  • pkrc_noncovid has 2278 outliers

year

categorical

Approximate Distinct Count 3
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 690000
  • The largest value (2021) is over 1.94 times larger than the second largest value (2020)

Length

Mean 4
Standard Deviation 0
Median 4
Minimum 4
Maximum 4

Sample

1st row 2020
2nd row 2020
3rd row 2020
4th row 2020
5th row 2020

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 40000
  • The top 2 categories (2021, 2020) take over 50.0%
  • The largest value (2021) is over 1.94 times larger than the second largest value (2020)
  • year has words of constant length

Interactions

Correlations

Missing Values